Bsfconfig for OLEDB |
This topic contains the structure of the bsfconfig file used for OLEDB driver. |
|
Using this code, create a bsfconfig file.
<configurations>
<configuration
htmfile="/cordys/cpc/bsf/developer/content/bsftabpage.htm" implementation="com.cordys.cpc.bsf.connector.BsfConnector">
<component name="Rule Engine">
<ruleAudit>false</ruleAudit>
<publishAudit>false</publishAudit>
<threadPoolSize>5</threadPoolSize>
<maxDispatcherQueueSize>50000</maxDispatcherQueueSize>
</component>
<component name="Rule Repository ConnectionPool">
<server>servername</server>
<userName>userName</userName>
<password>password in base64 encoded format</password>
<defaultDatabase>databasename</defaultDatabase>
<minimumReadConnections>1</minimumReadConnections>
<maximumReadConnections>5</maximumReadConnections>
<minimumWriteConnections>1</minimumWriteConnections>
<maximumWriteConnections>5</maximumWriteConnections>
<queryCacheSize>50</queryCacheSize>
<queryCacheRefreshInterval>3600</queryCacheRefreshInterval>
<cursorCacheSize>50</cursorCacheSize>
<cursorCacheRefreshInterval>3600</cursorCacheRefreshInterval>
<driverName>OLEDB</driverName>
<provider>OLEDB provider name(like SQLNCLI)</provider>
<vendor>SQL Server</vendor>
<xmlEncoding>false</xmlEncoding>
<multibyte>false</multibyte>
<refreshInterval>3600</refreshInterval>
</component>
<ruleEnabled>true</ruleEnabled>
<autoCleanup>false</autoCleanup>
<auditEnabled>off</auditEnabled>
<initializeDB>true</initializeDB>
<initializeEIS>false</initializeEIS>
<customInitializer>FQCN of class implementing IOnBsfConnector interface</customInitializer>
<bsfuser>cn=demousr,cn=organizational users,o=system,cn=cordys,o=vanenburg.com</bsfuser>
<component name="WS-AppServerConnectionPool">
<server>servername</server>
<userName>userName</userName>
<password>password in base64 encoded format</password>
<defaultDatabase>databasename</defaultDatabase>
<operatingsystem>windows</operatingsystem>
<maximumReadConnections>3</maximumReadConnections>
<maximumWriteConnections>7</maximumWriteConnections>
<queryCacheSize>50</queryCacheSize>
<queryCacheRefreshInterval>3600</queryCacheRefreshInterval>
<cursorCacheSize>50</cursorCacheSize>
<cursorCacheRefreshInterval>3600</cursorCacheRefreshInterval>
<driverName>OLEDB</driverName>
<provider>OLEDB provider name(like SQLNCLI)</provider>
<xmlEncoding>false</xmlEncoding>
<multibyte>false</multibyte>
<readEmptyStringAsNull>true</readEmptyStringAsNull>
<writeEmptyStringAsNull>true</writeEmptyStringAsNull>
<queryType>DBSQL</queryType>
<auditInfo/>
</component>
</configuration>
</configurations>